package org.lb.MarketingSystem.dao;

import java.util.List;
import org.lb.MarketingSystem.entity.Product;
import org.springframework.stereotype.Component;

@Component(value="productMapperDao")
public interface ProductMapperDao {
	public List<Product> select_AllProducts();    //得到所有产品信息
	public boolean updateProduct(Product product);  //修改产品信息
	public boolean dropProduct(Integer productId);   //删除产品
	public boolean insertProduct(Product product);    //添加产品
	public List<Product> selectProductsByType(String TypeName);   //根据类型得到该类所有产品信息
	public List<Product> selectProductsByPrices(double price1,double price2); //根据价格得到产品信息
	public List<Product> selectProductsByPriceAndTypeName(double price1,double price2,String TypeName); //根据价格和类型得到产品信息
	//根据类型查其下产品并分页
	public List<Product> selectproductByproductTypeID(int productTypeID);
	public List<Product> selectproductCountByType(int productTypeID);
	public List<Product> selectproductByPage(int productTypeID,int page);
}
